Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default deleting characters from beginning of call

is it possible to highlight multiple cells and delete characters from the
beginning of them?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,276
Default deleting characters from beginning of call

Hi,
do you have an example ?, if you want to delete let' say " you can do just
find and replace , find what ", replace with do not enter anything and clidk
on replace

"fazz" wrote:

is it possible to highlight multiple cells and delete characters from the
beginning of them?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 430
Default deleting characters from beginning of call



"fazz" wrote:

is it possible to highlight multiple cells and delete characters from the
beginning of them?


Can you give an example of some of the data? Is the data all the same
length? Do you always just want to removed 1 character from the front or
does that vary? There are formulas you can use to accomplish this but what
formula you use depends on what your data is like.
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default deleting characters from beginning of call

If the characters are the same in all cells just editreplace

One cell at a time use a helper column with LEFT or RIGHT fumctions.

e.g. =RIGHT(A3,LEN(A3)-2) will remove first 2 characters from A3

With VBA you can probably delete from all cells at once.

Is the data to be removed consistent?

Do you have any sample data you could post?


Gord Dibben MS Excel MVP

On Thu, 20 May 2010 08:51:01 -0700, fazz
wrote:

is it possible to highlight multiple cells and delete characters from the
beginning of them?


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default deleting characters from beginning of call

Hello Tim - what i really need to be able to do is remove blank spaces at the
beginning of a cell

"tim m" wrote:



"fazz" wrote:

is it possible to highlight multiple cells and delete characters from the
beginning of them?


Can you give an example of some of the data? Is the data all the same
length? Do you always just want to removed 1 character from the front or
does that vary? There are formulas you can use to accomplish this but what
formula you use depends on what your data is like.



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 430
Default deleting characters from beginning of call

You can use the 'Trim' function for this. It removes blanks spaces from a
cell except for blank spaces between words.

- Insert a column next to the column that needs to be changed.
- Enter the formula =TRIM(put the cell you want trimmed here)
- Then copy the formula down the as far as your data goes.

It should trim the leading blank spaces. You then can 'copy' the column
with the trim formulas and 'paste special'....values over top of original
column. Then just deleted the column with the TRIM formulas.

As with all changes to your data in a spreadsheet, make a back up copy of
your sheet before making any mass changes like this.

"fazz" wrote:

Hello Tim - what i really need to be able to do is remove blank spaces at the
beginning of a cell

"tim m" wrote:



"fazz" wrote:

is it possible to highlight multiple cells and delete characters from the
beginning of them?


Can you give an example of some of the data? Is the data all the same
length? Do you always just want to removed 1 character from the front or
does that vary? There are formulas you can use to accomplish this but what
formula you use depends on what your data is like.

  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,276
Default deleting characters from beginning of call

Hi,
Let' say the column with blank is column A in another column enter

=trim(A1)

copy formula down, then do copy, go to column A, paste as values

"fazz" wrote:

Hello Tim - what i really need to be able to do is remove blank spaces at the
beginning of a cell

"tim m" wrote:



"fazz" wrote:

is it possible to highlight multiple cells and delete characters from the
beginning of them?


Can you give an example of some of the data? Is the data all the same
length? Do you always just want to removed 1 character from the front or
does that vary? There are formulas you can use to accomplish this but what
formula you use depends on what your data is like.

  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default deleting characters from beginning of call

thanks...it all works now..

"Eduardo" wrote:

Hi,
Let' say the column with blank is column A in another column enter

=trim(A1)

copy formula down, then do copy, go to column A, paste as values

"fazz" wrote:

Hello Tim - what i really need to be able to do is remove blank spaces at the
beginning of a cell

"tim m" wrote:



"fazz" wrote:

is it possible to highlight multiple cells and delete characters from the
beginning of them?

Can you give an example of some of the data? Is the data all the same
length? Do you always just want to removed 1 character from the front or
does that vary? There are formulas you can use to accomplish this but what
formula you use depends on what your data is like.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleting with a referance...kinda...not sure what to call this!! dim Excel Discussion (Misc queries) 3 November 29th 07 11:09 AM
Deleting Characters Vinny0128 Excel Discussion (Misc queries) 2 May 7th 07 03:19 AM
Weird characters at beginning of cell jdelcour Excel Discussion (Misc queries) 3 July 18th 06 06:51 PM
How do I eliminate spaces/characters from the beginning of a cell A Waller Excel Worksheet Functions 1 June 29th 05 10:37 PM
add characters to beginning of text Natalie Excel Worksheet Functions 3 March 4th 05 01:56 PM


All times are GMT +1. The time now is 04:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"