Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
removing extra spaces
I am back again and, once again, have a long email list that I am going to
copy and paste from excel. For some reason this time every single cell has about 30 extra spaces after the email address. So when I use the =j2&";" function it puts the colon 30 characters after the email address... Any clue how I can quick and easily get those spaces off of there?? Thanks in advance for any help... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
removing extra spaces
Try
=TRIM(J2)&";" Mike "BVZ" wrote: I am back again and, once again, have a long email list that I am going to copy and paste from excel. For some reason this time every single cell has about 30 extra spaces after the email address. So when I use the =j2&";" function it puts the colon 30 characters after the email address... Any clue how I can quick and easily get those spaces off of there?? Thanks in advance for any help... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
removing extra spaces
Hi,
use the TRIM(A1) function -- Thanks, Shane Devenshire "BVZ" wrote: I am back again and, once again, have a long email list that I am going to copy and paste from excel. For some reason this time every single cell has about 30 extra spaces after the email address. So when I use the =j2&";" function it puts the colon 30 characters after the email address... Any clue how I can quick and easily get those spaces off of there?? Thanks in advance for any help... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing 2 extra spaces in front of dates in imported excel doc | Excel Discussion (Misc queries) | |||
removing spaces | Excel Discussion (Misc queries) | |||
eliminating extra spaces in Excel cells | Excel Discussion (Misc queries) | |||
Removing random extra spaces | Excel Discussion (Misc queries) | |||
Extra Spaces with copied data | Excel Discussion (Misc queries) |