add a space in a word on a specific column for a specific word in that column

Patricia Timm
Patricia Timm used Ask the Experts™
on
I have in a column DPA- I would like to change all of them to DPA -  
This would add a space between the DPA and the dash. IS there a way in excel to add the space and dash to those cells in the column? Thanks in advance
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
From the Home tab go to Editing - Find & Select and select Replace. In Find what enter DPA- and in Replace with enter DPA -.

Paul
Rob HensonFinance Analyst

Commented:
If you want it restricted to the specific column, select the data in that column before doing the Find and Replace; otherwise it will search the whole sheet and do replacements.

Author

Commented:
Question - I do not want to over write the existing words. So as an example in the cell it is DPA- Account or DPA- Money or DPA- Recieve.
I want the solution to be DPA - Account or DPA - Money but I do not want the words after affected. I will try and test to see the results.
Finance Analyst
Commented:
Find and replace won't affect the remainder of the cell, it will just replace occurrences of "DPA-" with "DPA -"

Author

Commented:
Thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial