Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding a space in text
Hello experts,
A previous employee created a spreadsheet whereas in Column A are employee names as follows: Doe,John Is there a formula that would add a space between the column and first name? Thanks so much for your help! I'm using Excel 2003. -- MB |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding a space in text
In an empty column, enter:
=SUBSTITUTE(A1,",",", ") HTH -- AP "MB" a écrit dans le message de news: ... Hello experts, A previous employee created a spreadsheet whereas in Column A are employee names as follows: Doe,John Is there a formula that would add a space between the column and first name? Thanks so much for your help! I'm using Excel 2003. -- MB |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding a space in text
This seems to work:
=LEFT(A1,FIND(",",A1)) & " " & RIGHT(A1, LEN(A1)-FIND(",",A1)) -- Kevin Vaughn "MB" wrote: Hello experts, A previous employee created a spreadsheet whereas in Column A are employee names as follows: Doe,John Is there a formula that would add a space between the column and first name? Thanks so much for your help! I'm using Excel 2003. -- MB |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding a space in text
=LEFT(A1,FIND(",",A1,1)) & " " & RIGHT(A1,LEN(A1)-FIND(",",A1,1))
-- Gary''s Student "MB" wrote: Hello experts, A previous employee created a spreadsheet whereas in Column A are employee names as follows: Doe,John Is there a formula that would add a space between the column and first name? Thanks so much for your help! I'm using Excel 2003. -- MB |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding a space in text
you said a formula, so
=LEFT(D4,FIND(",",D4)) & " "&MID(D4,FIND(",",D4)+1,LEN(D4)-FIND(",",D4)+2) -- Don Guillett SalesAid Software "MB" wrote in message ... Hello experts, A previous employee created a spreadsheet whereas in Column A are employee names as follows: Doe,John Is there a formula that would add a space between the column and first name? Thanks so much for your help! I'm using Excel 2003. -- MB |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding a space in text
WOW! You are all so wonderful! Thank you!!
-- MB "Don Guillett" wrote: you said a formula, so =LEFT(D4,FIND(",",D4)) & " "&MID(D4,FIND(",",D4)+1,LEN(D4)-FIND(",",D4)+2) -- Don Guillett SalesAid Software "MB" wrote in message ... Hello experts, A previous employee created a spreadsheet whereas in Column A are employee names as follows: Doe,John Is there a formula that would add a space between the column and first name? Thanks so much for your help! I'm using Excel 2003. -- MB |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding a space in text
If you want to insert the space and leave the text in the same column:
Select the column. Editreplacefind , replace with ,<space -- Carlos "MB" wrote in message ... Hello experts, A previous employee created a spreadsheet whereas in Column A are employee names as follows: Doe,John Is there a formula that would add a space between the column and first name? Thanks so much for your help! I'm using Excel 2003. -- MB |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding cells which include numbers and text | Excel Discussion (Misc queries) | |||
Adding text in formulas | Excel Worksheet Functions | |||
how do I combine workbooks, adding new text | Excel Discussion (Misc queries) | |||
Adding a space with =A59&B59 | Excel Worksheet Functions | |||
Adding a text label to a line. | Charts and Charting in Excel |